UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT9VDrgO0mB00OLt2tYbHd55kgCbiZULyakd7Tq4X3k='
WHERE
key_id = '12f249b4510d412ea59bd84a17ee502ed93d4c20a7a1943689df519a6cf15bf0'
AND (
token = 'XT9VDrgO0mB00OLt2tYbHd55kgCbiZULyakd7Tq4X3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)