UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cRunLNDXM5YApDO3giV4tIpKQDJqSn7UCBHgtl6Y1eE='
WHERE
key_id = 'ebedd1beb9ce98d160d44ac3694d94a5cc307b32c8a4620be3acac795bf530a2'
AND (
token = 'cRunLNDXM5YApDO3giV4tIpKQDJqSn7UCBHgtl6Y1eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)