UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xxd3lZUFHPnZMAX2hPRwpkiY7HxoDV/1soqAXz1wBSc='
WHERE
key_id = '866d67acbd31b138da7a0afbfdb75d97d714742ca18653677f4b9d5251f12636'
AND (
token = 'xxd3lZUFHPnZMAX2hPRwpkiY7HxoDV/1soqAXz1wBSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)