UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhjIFLayLL9arjLeo/9QyUmEJodAr/6RYYhqEG27oSI='
WHERE
key_id = '419421f3ea14053f78094134e7584d010985f92964d89c5eab59dd69031f3356'
AND (
token = 'BhjIFLayLL9arjLeo/9QyUmEJodAr/6RYYhqEG27oSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)