UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jYX506J64fW0jfLSGNvPbIgbLMfDPvA0g6z1E7hWyqs='
WHERE
key_id = '5254d05fd97ac5ca2ada9cde895483b14ad3f966605c512b506bbf2b873e19dd'
AND (
token = 'jYX506J64fW0jfLSGNvPbIgbLMfDPvA0g6z1E7hWyqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)