UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kCHFBy2VrcOv1USO+WZarrM7E+JoPa3D9vaKVnLUFZA='
WHERE
key_id = 'e75e3c019e5038a4d1920394308440fb333993a7a1794a02832d3b8be3bc191f'
AND (
token = 'kCHFBy2VrcOv1USO+WZarrM7E+JoPa3D9vaKVnLUFZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)