UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4RwyVSIo9lpjX1cLk0lN321SkhsBp+z11JLbvDudHjY='
WHERE
key_id = '0186e119925a2c8ae9530aa7196657ace08b78769dbf937c55a3f8bd1f95d002'
AND (
token = '4RwyVSIo9lpjX1cLk0lN321SkhsBp+z11JLbvDudHjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)