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