UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0DULFKMPp9WqK6DLk3dxKUyTdUtHGBNN8L9R+bpSag='
WHERE
key_id = 'f4165003aff7328f1d07df052e85bdcd125603498367b6e7f4a1f4f72491fc70'
AND (
token = 'X0DULFKMPp9WqK6DLk3dxKUyTdUtHGBNN8L9R+bpSag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)