UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVk2iXV1eM1PFqcYBQpIR9+EOfvb+M7hdoQWVx6REU4='
WHERE
key_id = 'c5e3546fccd05a9c82889861f31637e6a6a8d1f4017f64c63f10d54a2c5defb8'
AND (
token = 'cVk2iXV1eM1PFqcYBQpIR9+EOfvb+M7hdoQWVx6REU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)