UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BUfObP20oSiXGRYML/Zy1fbIX4A7qo/IflCQj25h3pk='
WHERE
key_id = 'd0e231c5dd3d782843fddafe896f41aaf437fa50d7df1217728f2b04935a7d8d'
AND (
token = 'BUfObP20oSiXGRYML/Zy1fbIX4A7qo/IflCQj25h3pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)