UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aYc196FeyTOSxgRRrLwHItIiFlYCUBE/JZaW02CXqv0='
WHERE
key_id = 'cc31634c116d061ada95b96eb3e3d999a0bb148a6f9ffb7958a035cfa4ddbbf2'
AND (
token = 'aYc196FeyTOSxgRRrLwHItIiFlYCUBE/JZaW02CXqv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)