UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a+zkn5qFyJYV2Z2YL9An1cWvmIEkah1m171hsl+4u4Q='
WHERE
key_id = 'a243835caaefc48e7f27403c0b971955e498723b9ccc43600e514ee7b589bbb0'
AND (
token = 'a+zkn5qFyJYV2Z2YL9An1cWvmIEkah1m171hsl+4u4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)