UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8g+DfBU5FBv4LF3W6kW/z2d9dQ/c5pL89Bxmkjci0Cw='
WHERE
key_id = 'fe8754ae14b70a5f831afdf47309b8a95f81c7e3e295ee096089f4f56d63f0af'
AND (
token = '8g+DfBU5FBv4LF3W6kW/z2d9dQ/c5pL89Bxmkjci0Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)