UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7FsjJIbia6TyyNYEkozOiLWC3r/JAgnWmA/j0V1xuFs='
WHERE
key_id = 'a12f280e6d8447532fdcb5128f9ae260be02ee6591add34aab4d8595b4d2598e'
AND (
token = '7FsjJIbia6TyyNYEkozOiLWC3r/JAgnWmA/j0V1xuFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)