UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ye+8yveZkh+Hx5JDE09oiPUx0P0+ymtkLEjUvL9Wmmw='
WHERE
key_id = 'a3b2dca514e9bc7be5097b34f930dda785a75911cdbdb77f9750525fc1aa892a'
AND (
token = 'Ye+8yveZkh+Hx5JDE09oiPUx0P0+ymtkLEjUvL9Wmmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)