UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzkYvEO4VueKNB82HRH1Xwl3F8C+0NJ4sfgZRIV3lTI='
WHERE
key_id = 'f397e7076f1c1061478057cc53c67d1c28694001a0b00473bf64937cabbba82a'
AND (
token = 'mzkYvEO4VueKNB82HRH1Xwl3F8C+0NJ4sfgZRIV3lTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)