UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zI4m6Tq20RQHo7hUNUry5sf0DoTjff6cwKjVNI/EE00='
WHERE
key_id = 'b5c582dffd4cee8084340a16a13b1685f5f751beb2bbe5bfa5b6f57e4a9045f8'
AND (
token = 'zI4m6Tq20RQHo7hUNUry5sf0DoTjff6cwKjVNI/EE00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)