UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'obRZmsQlCSY8sqnNMecAFyw1E4TkxPip965a/cLLwnI='
WHERE
key_id = '43fa711524ec803de75ed6c04e40fe8379b106edbc5cabe5ccb4e31d03ea6b97'
AND (
token = 'obRZmsQlCSY8sqnNMecAFyw1E4TkxPip965a/cLLwnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)