UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cACZJeBOWW3xvJCQlrrcrxStbk83/+TCKD66PzmUoYI='
WHERE
key_id = '557b03d7aadde8254ef5d358570bae8de714302b6d478879b5b936ec80ba5373'
AND (
token = 'cACZJeBOWW3xvJCQlrrcrxStbk83/+TCKD66PzmUoYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)