UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h3wUnEoKZ4XlIN5zd5dkqQXlgL84VqTNUwN9Ah6gg8k='
WHERE
key_id = '7fef4eeda8329124f9e35b61487de4443da65270610534a0a9c67db09867b84a'
AND (
token = 'h3wUnEoKZ4XlIN5zd5dkqQXlgL84VqTNUwN9Ah6gg8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)