UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwtFUtv5ogEgVWRMF27zMab0Ckts9ARMe0pGBot6hhI='
WHERE
key_id = 'b351a8da2b49bf955c14e459c1de6ccd5428be1c19d03f0d0cb9a447f3f98abf'
AND (
token = 'ZwtFUtv5ogEgVWRMF27zMab0Ckts9ARMe0pGBot6hhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)